﻿

 alter PROCEDURE PomPomplingCustomerSave
(
	@pPomplingCustomerID varchar(32), 
	@pUserName varchar(60), 
	@pEmail varchar(100), 
	@pPomplingPassword varchar(16), 
	@pIsCompany bit
)
AS
BEGIN
	SET NOCOUNT ON;
	
	INSERT INTO PomPomplingCustomers( PomplingCustomerID, UserName, Email, PomplingPassword, IsCompany)
	VALUES (@pPomplingCustomerID, @pUserName, @pEmail, @pPomplingPassword, @pIsCompany);
	--SET @pPomplingCustomerID = SCOPE_IDENTITY();
	select @pPomplingCustomerID;
 END